Skip to main content

SLAM_metadata_objects

Overview​

Retrieves Salesforce object definitions to table METADATA_OBJECTS.

warning

The list of objects returned is subject to Salesforce permissions. Only the objects the user has access to in Salesforce are returned.

Parameters​

NameTypeDefaultDescription
@exists_actionVARCHAR(20)NULLControls the behavior when the destination object METADATA_OBJECTS already exists. If NULL, uses the value from SLAM_Settings.default_exists_action (defaulted to 'drop' during initial setup).

Valid options:

  • 'drop' - Drop the existing object and create a new one (default)
  • 'rename' - Rename the existing object by appending a timestamp suffix (format: _YYYYMMDDTHHMMSS_MMM)
  • 'fail' - Throws a SQL exception if the destination object already exists

Usage Examples​

EXEC dbo.SLAM_metadata_objects;

SELECT * FROM METADATA_OBJECTS;

With explicit exists action:

EXEC dbo.SLAM_metadata_objects
    @exists_action = 'rename';